SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
AND list_price BETWEEN '250000' AND '500000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 20
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Welcome to 60 Church Street, a spacious and well-maintained home located in the heart of Lebanon, New Hampshire. Situated on a quiet street just steps from downtown amenities, this property offers an ideal combination of comfort, convenience, and flexibility for a variety of living arrangements. The home features generously sized bedrooms, providing ample space for residents, guests, or home office setups. Thoughtful storage solutions can be found throughout the property, a rare and highly desirable feature that helps keep living spaces organized and functional. From closets and built-ins to additional storage areas, there is room for everything without sacrificing living space. Gorgeous hardwood floors throughout and a quaint yard with deck. One of the property's standout advantages is its location. Downtown Lebanon's restaurants, shops, parks, and community amenities are all within easy reach, while major commuter routes provide convenient access throughout the Upper Valley region. The home is also located just a short drive from Dartmouth Hitchcock Medical Center. Whether used as a primary residence, a long-term rental property, or a home with room-rental potential, 60 Church Street offers exceptional versatility. The layout provides privacy and comfort, while the home's size and storage capacity make it practical for multiple occupants. Minutes from downtown and great views of Storrs Hill historic Erling Heistad 50-meter ski jump, one of New England's most recognized community ski-jumping venues. Great location, great price!
Description:Summers spent on sandy beaches are a must with how close this home is to North Cove Beach of Eastman Lake. Outdoor features include a nice level lot with mature landscaping and an updated roof, while inside features an updated kitchen and appliances, propane stoves in the living and family rooms, and a large sun-filled room for year-round enjoyment. This 3-bedroom, 2-bath home has a split-level entry with all bedrooms on the main level and a spacious family room on the lower level. Eastman offers exceptional amenities, including lake activities, a championship golf course, tennis, pickleball, groomed cross-country ski trails, miles of walking and hiking trails, an indoor pool, exercise facility and more! Conveniently located just minutes from the Upper Valley and Lake Sunapee regions and only two hours from Boston. Eastman provides a chance to connect with nature through seasonal recreation and connect with people through welcoming community activities.